using System;
using System.Data;
using System.Collections.Generic;
namespace eTMS.DAO
{
    /********************************BEGIN SoNoSinhVienChiTietDAO****************************************/
    ///<summary>
    /// <para>Author: Auto generated class by CSharp Code Generator v2.0</para>
    /// <para>Date:16/08/2010 29:02:17</para>
    /// <para>Class Name: SoNoSinhVienChiTietDAO</para>
    /// <para>Description: Class access to table SoNoSinhVienChiTiet in database. Class for coder code here</para>
    ///</summary>


    public partial class SoNoSinhVienChiTietDAO
    {
        public DataSet SelectAllDSWithKhoanTienBySoNoSinhVien_ID(int SoNoSinhVien_ID)
        {
            IDbCommand cmd = this.CreateCommand();
            cmd.CommandText += @"SELECT        KhoanTien.MaKhoanTien, KhoanTien.TenKhoanTien, SoNoSinhVienChiTiet.SoNoSinhVienChiTiet_ID, SoNoSinhVienChiTiet.SoNoSinhVien_ID, 
                                    SoNoSinhVienChiTiet.KhoanTien_ID, SoNoSinhVienChiTiet.SoTien
                                FROM    SoNoSinhVienChiTiet INNER JOIN
                                        KhoanTien ON SoNoSinhVienChiTiet.KhoanTien_ID = KhoanTien.KhoanTien_ID
                                WHERE SoNoSinhVienChiTiet.SoNoSinhVien_ID=" + SoNoSinhVien_ID.ToString();
            return this.SelectDS(cmd);
        }

    }
    /*****************************************************************************************************/
    /**********************************END SoNoSinhVienChiTietDAO*****************************************/
    /*****************************************************************************************************/
}

